package com.dfiov.cloud.msmtools.mapper.tspreport;


import com.dfiov.cloud.msmtools.entity.dto.AddDataByMonthDto;
import com.dfiov.cloud.msmtools.entity.vo.tspReport.BaseAccountStaticExcelVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TspReportMapper {

    //新增量统计
    List<AddDataByMonthDto> getAddDataByMonth(@Param("startMonth")String startMonth, @Param("endMonth")String endMonth);

    //明细
    List<BaseAccountStaticExcelVo> getAddDataByMonthAndVersion(
            @Param("vin")String vin,
            @Param("startMonth")String startMonth,
            @Param("endMonth")String endMonth,
            @Param("versionList")List<String> versionList,
            @Param("offset")int offset,
            @Param("limit")int limit);


    //总数
    int getAddDataByMonthAndVersionCount(
            @Param("vin")String vin,
            @Param("startMonth")String startMonth,
            @Param("endMonth")String endMonth,
            @Param("versionList")List<String> versionList
    );

    //导出
    List<BaseAccountStaticExcelVo> exportAddDataByMonthAndVersion(
            @Param("vin")String vin,
            @Param("startMonth")String startMonth,
            @Param("endMonth")String endMonth,
            @Param("versionList")List<String> versionList);
}
